AcademicAdvisor

EntityType | Independent
Logical Entity Name | AcademicAdvisor
Default Table Name | AdAdvisor
Logical Only | YES
Owner |
Definition |
    CREATE VIEW dbo.AdAdvisorASSELECT     syStaff.code,     systaff.sycampusgrpid,     systaff.lastname,         systaff.firstname,     systaff.addr1,     systaff.addr2,     systaff.city,         systaff.state,     systaff.zip,     systaff.phone,     systaff.active,         systaff.userid,     systaff.dateadded,     systaff.datelstmod,         systaff.descrip,     syStaff.syStaffID AS AdAdvisorIDFROM syStaffByGroup (nolock)LEFT OUTER JOIN syStaff (nolock)   ON syStaff.syStaffID = syStaffByGroup.syStaffID LEFT OUTER JOIN syStaffGroup (nolock)   ON syStaffGroup.syStaffGroupID = syStaffByGroup.syStaffGroupIDWHERE syStaffGroup.code = 'ACAD'
Note |

AcademicAdvisor Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition

AcademicAdvisor Keys

Key Name | Key Type | Keys

AcademicAdvisor Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

AcademicAdvisor Check Constraints

Check Constraint Name | CheckConstraint

AcademicAdvisor Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical AcademicAdvisor | NO |  |  |
Physical (Microsoft SQL Server) Does Not Exist | NO |  |  |

AcademicAdvisor Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model

AcademicAdvisor Data Movement Rules

Name | Type | Rule Text/Value